Page 54 - Data_Science_Part_A C12

Suppose, the data entered in cells A1, A2, A3 and A4 are 5, 15, 20 and 60 respectively. In cell A5, a formula is entered to
calculate the sum of these numbers with their cell address; thus it will be displayed as ‘=A1+A2+A3+A4’.

Here, the output will be 100 that will be displayed in the cell A5 as soon as the ‘Enter’ key is pressed.

3.10.4 Using Mouse to Select Values

Using the mouse to select values is a simple and efficient way to create formulas by directly selecting cells instead of
manually typing their references.
Perform the following steps to select values using the mouse:
Step 1: Click on the cell where you want the result.
Step 2: Type = to begin your formula.

Step 3: Use the mouse to click on the cell that contains the first value to include in the formula.
Step 4: Type an operator like +, -, *, or / to indicate the desired calculation.
Step 5: Click on other cells to include them in the formula. Each reference will appear in the formula as you select it.
Step 6: Press Enter key to complete the formula and view the result.
For example: Type =D2+D3+D4+D5+D6, the result will be 15.

3.10.5 Functions
=SUM(A1:A5)
Functions are in-built formula in LibreOffice Calc that can
be used to perform arithmetical and non-arithmetical
tasks. A function contains Name and Argument.

Name Argument

52 Touchpad Data Science-XII